The Copy Special utility
When copying and pasting data from a List View into another application a problem can arise when a column in the EMu List View contains paragraphs of text or tables of values. In some instances, one or more carriage return symbols (a square box) may display in place of a newline; data from separate rows may display on a single line, etc.:
This can occur because different applications and platforms expect a particular character at the end of a paragraph (in text fields) or at the end of a row (in a table of values) and that character may be different from that which EMu uses by default. For instance:
- Macintosh computers expect a Carriage Return (
CR
) at the end of a paragraph. - Applications such as Microsoft Word on a Windows platform expect a Carriage Return and a Newline (
CR+NL
). - Applications in a UNIX environment expect a Newline (
NL
). - Microsoft Excel on a Windows platform expects a Newline (
NL
). - Other applications may expect some other character or combination of characters.
The Copy Special utility allows you to specify what character(s) or notation should be used at the end of a paragraph or row:
Scenario: you wish to copy data from a List View in EMu in which one of the columns is a table of values (e.g. Other Names: (Person Details) in the Parties module). When you paste the data into Excel, data that was in separate rows in the table of values displays in one row, separated by two square boxes in place of carriage returns:
In this example, we searched for all Parties records with more than one Other Name:
We selected a List View that includes Other Names: (Person Details) and copy the records:
We pasted the records into Microsoft Excel:
In Excel we could format the column so that the two values display as separate rows (as they did in EMu) by:
- Highlighting the Other Names: (Person Details) column by selecting the column header (in the example above, you would select the C).
- Right-clicking anywhere in the highlighted column.
A context menu displays.
- Selecting Format Cells.
The Format Cells dialogue displays.
- Selecting the Alignment tab.
- Placing a tick in the Wrap text checkbox.
- Clicking OK.
The values now display in separate rows, however one of the carriage return symbols still displays:
With the Copy Special utility we can avoid this problem.
- Search for or retrieve a group of records.
- Select or create a List View with the required fields.
- Select the records.
- Select Copy>Copy Special on the Edit tab of the Ribbon to display the Copy Special box:
- If a column in your List View is for:
- Paragraphs of text (a Notes field for example), select a Line Delimiter radio button
-OR-
- A table of values (e.g. Other Names: (Person Details) in the Parties module), select a Row Delimiter radio button.
Note: Selecting one of these radio buttons places the appropriate delimiter at the end of a row or paragraph.
Select the appropriate radio button for the application / platform into which you will paste the data. For example:
Line / Row Delimiter Description
CR
Macintosh platform.
CR+NL
Windows applications (e.g. Microsoft Word, but not Microsoft Excel).
NL
UNIX; Microsoft Excel on a Windows platform.
Other
Select the Other radio button:
- If you wish to specify the character(s) / symbol(s) that will separate paragraphs / rows (e.g. a pipe | symbol).
-OR-
- If the application into which you wish to paste the data requires non-printable character(s), for instance Octal (Base 8) notation, e.g. a backslash followed by up to 3 octal numbers:
\007
.
- Paragraphs of text (a Notes field for example), select a Line Delimiter radio button
- Paste the data into your application of choice!
If we return to our Microsoft Excel example, and select NL under Row Delimiter, we have the following result when we paste the data into Excel:
Note: Do not use Copy Special if you wish to copy data out of EMu in order to clean it up and then re-import it. When you re-import the data, the modified delimiter will also be imported and the data may not display properly in EMu.